PL-300: Microsoft Power BI Course Online

8 Lesson

24 Hours

5 (10 reviews)

Add to Wishlist

Power BI is a powerful business intelligence (BI) and data visualization platform developed by Microsoft that enables organizations to turn raw data into clear, actionable insights through interactive dashboards and reports. igmGuru’s Power BI Training is specifically customized according to the official Microsoft PL-300 certification objectives. This training is delivered by experienced BI professionals with expertise in enterprise reporting, dashboard architecture, and Microsoft ecosystem integration.

Enroll Now

PL-300 Aligned Power BI Course Overview

igmGuru’s Power BI Training course is designed for beginners and professionals aiming to become certified Power BI Data Analysts. The program covers Power BI from foundational concepts to advanced business intelligence development. In this training program, you’ll start with the fundamentals of data analytics and progress to advanced dashboard design, DAX calculations, data modeling, and cloud deployment.

By the end of the course, you’ll be able to design interactive dashboards, create analytical reports, automate reporting processes, and confidently implement Power BI solutions in real-world business environments.

What You Will Learn in This Power BI Training Course?

Beginner Level (Prepare the Data)

Business Intelligence fundamentals and Power BI ecosystem.
Connecting to multiple data sources (Excel, CSV, SQL Server, Web, Cloud platforms).
Data profiling, cleaning, and transformation using Power Query.
Handling data errors, missing values, and query optimization basics.

Intermediate Level (Model & Visualize the Data)

Data modeling fundamentals, including relationships, cardinality, Star Schema, and Snowflake Schema.
Creating calculated columns and measures using DAX, including core functions and time intelligence functions.
Designing interactive reports and dashboards with advanced visualizations, formatting, drill-through, tooltips, bookmarks, slicers, and filters.
Implementing Row-Level Security (RLS).

Advanced Level (Analyze & Deploy)

Performance optimization techniques for reports and models.
Managing datasets in Power BI Service, including scheduled refresh and gateway configuration.
Workspace management, collaboration, deployment pipelines, dataflows, and shared datasets.
Governance, security best practices, and enterprise deployment strategies.
Real-time dashboards, streaming datasets, and usage metrics monitoring.
PL-300 exam strategy with practice scenarios.

Who Should Enroll in This Power BI Training?

Aspiring Power BI Developers
Data Analysts and BI Professionals
MIS Executives
Finance & Accounting Professionals
IT Professionals
Business Analysts
Reporting Analysts
Professionals preparing for PL-300 certification

Prerequisites of Power BI Training Course

Basic understanding of Excel.
Familiarity with data concepts.
No programming knowledge required.
Basic knowledge of databases (helpful but not mandatory).

Career Opportunities After This Training

After completing this PL-300 aligned training, you can apply for roles such as:

Power BI Developer
Microsoft Certified Power BI Data Analyst
Business Intelligence Developer
Data Analyst
BI Analyst
Reporting Specialist
Analytics Consultant

Benefits of Microsoft Power BI Online Training

Better Designation: BI experts hold positions like BI Developer, Data Analyst, Microsoft Business Intelligence Analyst, and Visualization Specialist.
Salary: Competitive salary packages with attractive additional benefits.
Hiring Companies: Infosys, Tata Consultancy Services, and KPMG are among the companies actively hiring professionals with Business Intelligence skills.

About igmGuru’s Microsoft Power BI Course Online

Understand the roles and responsibilities of Power BI Data Analysts. The course module keeps learners updated on the latest technological developments in the industry and focuses on the most relevant trends to help them stay ahead in the Business Intelligence domain.

Key Features

Experienced & Professional Trainers
24 X 7 Lifetime Support & Access
1 On 1 Training Option Available
Flexible Schedule
Small Batches Upto 10 Participants
Instructor Led Training: 24 Hrs

Power BI Course Syllabus

Lesson 1 - Power BI Advanced Features

1. Working with Data Hierarchies

2. In-built slicers and custom slicers • Date slicer

3. Working with reference lines

4. Dynamic Texts • Measures for Dynamic Texts

5. Dynamic tooltips

6. Filters • Types of Filters • Visualization filters • Page Filters • Report Filters

7. Drill Through • Creating Drill Through Reports

8. Developing KPIs

9. Parameters • Types of Parameters • Linking Parameters with Datasets • Creating Parameters for Data Sources • Creating Parameters for File Paths

10. Templates • Difference between Reports & Templates

11. Key Influencers

12. What-If Parameters • Creating What-If Parameters • Case Study on What-If Parameters

13. PL-300 Question & Answers

14. Interactions • Edition Interactions

15. Selection Pane • Hiding / UnHiding Using Selection Pane

Lesson 2 - OLAP & Power BI

1. OLAP Data Sources

2. Using Analysis service

3. Using MDX Queries

4. Connecting Power BI with OLAP

5. Understanding Import & DirectQuery

6. MDX SELECT and Perspective Access

7. MDX Expressions

8. MDX Queries

9. Applying Vertipaq Analyzer to analyze the structure of a data model

Lesson 3 - DAX functions

1. Working with DAX Functions

2. Calculated Measures by using DAX

3. Parameters with DAX

4. Dynamic Report Filters, Expressions • Variables

5. Date functions • String functions • Arithmetic Functions

6. Understanding Calculated Column • Creating Calculated Columns

7. Understanding Measures • Creating Measures • Difference between Columns & Measures

8. Logical Functions • Relationship functions • Math/Statistics function • Information functions

Lesson 4 - DAX Expressions & DAX Functions

1. Time intelligence function

2. YTD, QTD, MTD Calculations with DAX

3. DAX Calculations and Measures

4. Using TOPN, RANKX, RANK.EQ • SAMPLE Function, COUNTALL, ISERROR • ISTEXT, DATEFORMAT, TIMEFORMAT

5. Time Intelligence Functions with DAX

6. Data Analysis Expressions and Functions

7. DATESYTD, DATESQTD, DATESMTD • ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH • FIRSTDATE, LASTDATE, DATESBETWEEN

8. CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR • SAMEPERIOD and PREVIOUSMONTH,QUARTER

9. PARALLEL PERIOD • FILTER FUNCTIONS

10. How to use DAX Studio • Creating and Utilizing Variables

11. Understanding Nested Evaluation Context • Dynamic Bucketing/Binning using Lookup Functions

12. Scope Altering Functions (ALL, ALLEXCEPT, ALLSELECTED, KEEP FITLERS etc.)

13. Table Functions in DAX - CALCULATETABLE etc.

14. Time Intelligence (YTD, MoM, Rolling Window i.e. Moving Average calculations etc.)

15. Iterator Functions like SUMX, COUNTX, AVERAGEX ..

16. Many to Many Relationships and Bi directionality i.e. non Star Schema

17. Composite Models • Calculation Groups

18. DAX Patterns - Top N Pattern, ABC Pattern etc.

19. Using Path Function for Hierarchal Role based Access

20. Using DAX for SVG Animations

Lesson 5 - Power BI Custom Visuals & Advanced Forecasting Analysis

1. Adding Custom Visuals

2. Word Cloud • Text Filters • Tornado • Zebra BI Tables • Hierarchy Charts

3. Creating Automatic Forecasts • Time Series Forecasting • ARIMA Forecasting

4. Interactive Pareto Charts

5. Regression - Linear,Multiple Logistic • Correlation • Clustering Analysis

Lesson 6 - Power Query / MQuery

1. What is Power Query • When to Use Power Query

2. Connecting Data Sources using Power Query • Manipulating Data using Power Query

3. Power Query Functions • Applying Power Query Functions

4. Connecting to data sources using Power Query • Functions in Power Query

5. Importing and parsing JSON, XML, Web and API

6. Using Advanced Editor for the M Query Language

7. Difference in List, Record and Tables and their respective functions

8. M Language Basics (Text, Number, Date, Time, Duration Functions) , Conditional Functions IF then, Each Function

9. Creating and Using Lists and Records • Converting Lists to Tables and Using Tables

10. Different Join Types especially Self Joins

11. Creating Custom FUNCTIONS and using them in the CUSTOM COLUMN

12. Using Parameters and Parameter Tables in Power Query • Creating and Using Date Tables for Time Intelligence

Lesson 7 - Deployment & User Management

1. Understanding Cloud Architecture • Server Configuration

2. Cloud Account and Workspace • Creating Account and Services

3. Power BI Users • Types of Users -> Free, Pro, Premium

4. Creating Workspaces

5. User Management • Workspaces Management

6. Deployment Power BI Desktop Reports • Managing report and Services

7. Editing Reports in Business Intelligence Servers • Downloading PBIX files from Server

8. Share dashboards to Client /Users

9. Gateways • PowerBI Gateway -Download and Installation

10. Data Refresh with Business Intelligence Architecture

11. Power BI Settings : Dataset -Gateway Integration

12. Configuring Dataset for Manual Refresh • Configuring Automatic Refresh and Schedules

13. Subscriptions • Alerts

14. Dataset Actions and Refresh Settings with Gateway

15. Security Features • Implementing Row Level Security (RLS) • Security Roles and Role Members

16. Power BI Mobile Apps • Viewing Reports in Power BI Mobile Apps • Testing Reports for Mobile Views

17. Deployment Pipeline • WorkFlows

Lesson 8 - Power BI Performance Monitor

1. Performance Analyzers

2. Monitoring Performance using Performance Analyzers

3. Recording Duration time in milliseconds for each visual and Events

4. Identifying Bottlenecks in Reports

5. Optimizing Reports

Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)

+91 7240740740 (India)

Drop Us a Query

Fields marked * are mandatory

Name

Phone Number

Comments

Request For Live Demo Class

Power BI Course Fees

SELF PACED LEARNING

US $ 199.00

Refund Policy

Duration : 20 hrs
Lifetime Free Upgrade
Reference Documents
24x7 Support & Access

WATCH 1st CLASS FREE

Online Class Room Program

US $ 499.00

100% Money Back Guarantee

Duration : 20 Hrs
Plus Self Paced

Classes Starting From

Fast Track Batch 06 Jun 2026
Weekday Batch 08 Jun 2026
Weekend Batch 06 Jun 2026

Corporate Training

Customized Training Delivery Model
Flexible Training Schedule Options
Industry Experienced Trainers
24x7 Support

Trusted By Top Companies Worldwide

Want to know Today's Offer

PL-300 Certification & Exam Details

igmGuru’s Power BI course is aligned to ace the Microsoft Certified: Data Analyst Associate certification exam. The exam is conducted online at test centres or proctored by Pearson VUE from the user's home or office location worldwide.

Exam details

Exam fee: $165 USD
Passing score: 70%
Time Duration: 120 minutes
Number of Questions: 40-60
Format: MCQs, Multi-response questions and hands-on

Power BI Online Training FAQ

Is this course aligned with the latest PL-300 syllabus?

Yes, the curriculum follows Microsoft’s official exam objectives.

Is this course suitable for beginners?

Yes. It starts from the basics and progresses to advanced exam-level topics.

Will I get hands-on practice?

Yes. You will work on real-world datasets and dashboard projects.

Is Power BI suitable for non-technical professionals?

Yes. Power BI is widely used by finance, sales, HR, operations, and management professionals. No coding background is required.

Will I learn DAX from scratch?

Yes. The course covers DAX from fundamentals to advanced calculations, including time intelligence and performance optimization.

1-800-7430-173

(US Toll Free)

+91-7240-740-740

(India)

+91-7240-740-740

(WhatsApp)

info@igmguru.com

Reviews

Rating 5/5 based on 10 reviews

Login

Email ID*

Password*

Forgot Password?

Don't have an account?

Gagneet Khurana

22-Jan-2026

PowerBI - Dilip- Well designed and well executed course

I took a 1 week course to learn Power BI. Course is well designed to develop good understanding of the contents, hands-on reports building side by side, followed by practice assignments. Trainer is very well skilled, answered all my queries, flexible to alter course as per my specific requirements. Other staff is also very professional. Thanks igmGuru.

Sanjukta Das

02-Dec-2025

Power BI

I took the Power BI certification and SQL training with igmGuru, and it was a very smooth learning experience. The trainer covered every concept in detail, supported with practical examples and real-time demonstrations. The study materials, videos, and documents were well-structured and easy to follow. The support team was always quick to respond, and I appreciate the help I received when I needed the course content re-uploaded. Overall, a reliable platform for learning Power BI and building strong BI skills. Highly recommended!

Manjusha Pampana

25-Sep-2025

Power BI One on One training

I completed a Power BI course at IGM Guru, which was a fast-track one to one program led by trainer. He was very flexible with scheduling and patiently addressed all my doubts. I noticed steady progress throughout the course, and both the trainer and the coordinators were extremely supportive and helpful. The sessions were well-structured and focused on practical learning. Overall, it was a great experience that boosted my confidence in using Power BI.

Ramesh kumar Natarajan

20-Aug-2025

Trainer Dileep for Power BI/Query and Automate

Thanks a lot for 3 day training about Power suite product. It was helpful to understand and patienly the trainer explained and repeated wherever it is complex since we are from finance background. Thanks a lot for good session

Christine Atabug

04-Aug-2025

Power BI Training

I recently completed a 16-hour Power BI training session, and I found it to be both interesting and highly informative. The trainer was knowledgeable; he was able to explain complex concepts clearly and understandably. Additionally, the trainer was flexible, accommodating questions and tailoring the training to suit my needs and our time difference. Overall, a great learning experience that has significantly enhanced my skills in Power BI. Thank you.

Natasha Correia

17-Jul-2025

Benefit Oriented

This Power BI course was a fantastic experience, .the classes was very interactive and short. The Professor made sure the lecture was finished within the given time. 1 hour of the class was focused on teaching and the other hour for giving assignments and self studying. This approach meant I rarely needed to study outside of class, as the instructor ensured comprehensive learning within the allocated time. The advanced PDFs, assignments, and notes were beneficial for my Power BI success. Overall it was a very good practice and explanations was very clear.

Anish Sheth

31-Jan-2025

Power BI one on one training

Class is definitely good, but could be better if it was a little more structured in terms of syllabus. I agree that my case was unique as I already have over 20 years of IT experience and so my syllabus had to be altered for my individual needs. Knowledge of trainer is good and can communicate effectively. I am giving this opinion only to make them better as with a good and effective syllabus, this class would be awesome. It is very good right now but needs to become awesome.

Sarangan Venugopalan

25-Jan-2025

Useful product

Presently undergoing Power BI course. It is intensive and well designed. Hoping to achieve what I subscribed for. Recommend this useful course.

Anu Puthukulangara

15-Jan-2025

Power BI

I am extremely pleased with the exceptional quality of the training provided. Throughout the course, the igmGuru team demonstrated outstanding professionalism, ensuring a smooth learning experience. The program perfectly aligned with my objectives, surpassing my expectations. One of the most valuable aspects has been the flexibility of the trainer, who adapted the schedule to accommodate my working hours, considering the time difference. His advanced level of knowledge in the subject matter has been particularly beneficial. It has empowered me to implement meaningful changes to my dashboards within the Oil and Gas EPC industry, directly enhancing my work. I am confident the remaining lessons will maintain the same high standard of instruction. I am sincerely grateful to igmGuru for providing such an invaluable learning experience.

Prasanth Kumar

22-Aug-2023

Power BI

The training delivered was of exceptional quality. Throughout the course, the coordinators, Ketki and Shashi, exhibited a consistent and exemplary level of professionalism. The program aligned perfectly with my objectives, exceeding my expectations. I am genuinely delighted with the caliber of instruction I received. The trainer's profound expertise and mastery over the subject matter were evident, as they adeptly addressed queries and provided precisely the kind of training I sought. My sincere thanks to igmGuru for this invaluable learning experience.